package com.loyal.loyalerp.system.mapper.provider;

public class GySystemProvider {
	//根据systemcode查systemname
	public String selectSystemNameBySystemCode(String systemcode) {
		return "select * from gy_system where systemcode='"+systemcode+"'";
	}
	
	//根据systemname查systemcode
	public String selectSystemCodeBySystemName(String systemname) {
		return "select * from gy_system where systemname='"+systemname+"'";
	}
	
	public String listGySystem(String sidx,String sord) {
		return "select * from gy_system order by "+sidx+" "+sord;
	}
	
	public String findGySystem(String searchField,String searchString) {
		return "select * from gy_system where "+searchField+" like CONCAT(CONCAT(\'%\',\'"+searchString+"\',\'%\'))";
	}
}
